package cn.gson.springboot.model.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.alibaba.fastjson.JSONArray;

@Mapper
public interface HealthMappers {
	
	//新增体检
	public void AddHealth(@Param("project_no")Integer projectno,
						@Param("lookillness_id")Integer lookillnessid,
						@Param("clinic_id")Integer clinicid,
						@Param("health_money_status")Integer healthmoneystatus,
						@Param("health_type")Integer healthtype);
	
	//新增体检预约
	public void AddHealthAppoint(@Param("clinic_id")Integer clinicid,
			@Param("project_no")Integer projectno,
			@Param("meal_no")Integer mealno,
			@Param("appo_people")String appopeople,
			@Param("appo_status")Integer appostatus);
	
	//修改体检 预约的状态
	public void updateAppointSatus(@Param("appoid")Integer appoid);
	
	//体检退费，修改是否交钱的状态
	public void  updatehealmoneysate(@Param("clinicid")Integer clinicid);  
	
	//查询自主体检的记录
	public JSONArray selectHealthAppointAll();
	
	//体检查看详情体检项目
	public JSONArray selectHealthAppointDetials(@Param("clinicid")Integer clinicid);
	
	//查询门诊，住院的体检信息
	public JSONArray selectHealTwoRecordAll();
	
	//门诊，住院体检的详情体检项目
	public JSONArray selectHealTwoRecordDetils(@Param("clinicid")Integer clinicid);
	
	//查询体检报告
	public  JSONArray selectHealthproAll(@Param("clinicname")String clinicname);
	
	//查询所有体检项目
	public JSONArray selectByHealAll();
	
	//根据科室id与项目名称查询
	public JSONArray selectHealBysid(@Param("projectname") String projectname);
	
	//根据套餐查询具体的项目
	public JSONArray  selectMealProjectByid(@Param("mno") Integer mno);
	
	//查询体检套餐
	public JSONArray selectMealProjectAll();

}
